package com.example.mapper;

import com.example.pojo.OperateLog;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface OperateLogMapper {

    /**
     * 分页查询操作日志
     */
    @Select("select " +
            "ol.id, ol.operate_emp_id, ol.operate_time, ol.class_name, ol.method_name, ol.method_params, ol.return_value, " +
            "ol.cost_time, e.name operateEmpName " +
            "from operate_log ol left join emp e on ol.operate_emp_id = e.id " +
            "order by operate_time desc")
    List<OperateLog> list();


    /**
     * 插入操作日志
     */
    @Insert("insert into operate_log (operate_emp_id, operate_time, class_name, method_name, method_params, return_value, cost_time) " +
            "values (#{operateEmpId}, #{operateTime}, #{className}, #{methodName}, #{methodParams}, #{returnValue}, #{costTime})")
    void insert(OperateLog log);

}
